| 1 |
CHANNEL
[character] |
|
|
 |
0
(0.0%) |
| 2 |
ITEMID
[character] |
| 1. DCATA040BTHK02 | | 2. DLBSC120BXHK01 | | 3. DLJSC120BXHK01 | | 4. FDC02014 | | 5. FDC07016 | | 6. FDC45016 | | 7. FGB016 | | 8. FHP013 | | 9. FHP013TWFJT01C | | 10. FIS014 | | [ 73 others ] |
|
| 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 2809 | ( | 81.9% | ) |
|
 |
0
(0.0%) |
| 3 |
DATE
[Date] |
| min : 2021-01-01 | | med : 2022-04-01 | | max : 2023-07-01 | | range : 2y 6m 0d |
|
31 distinct values |
 |
0
(0.0%) |
| 4 |
PROD_REV
[numeric] |
| Mean (sd) : 199145.7 (485628.2) | | min ≤ med ≤ max: | | -199 ≤ 5581.2 ≤ 5500000 | | IQR (CV) : 172673.7 (2.4) |
|
1489 distinct values |
 |
0
(0.0%) |
| 5 |
PROD_QTY
[numeric] |
| Mean (sd) : 845.7 (5225.7) | | min ≤ med ≤ max: | | -1 ≤ 0 ≤ 130148 | | IQR (CV) : 451 (6.2) |
|
1081 distinct values |
 |
0
(0.0%) |
| 6 |
DATAAREAID
[character] |
1. vghp |
|
 |
19
(0.6%) |
| 7 |
ITEMNAME_ENG
[character] |
| 1. Extra Strength Uricsil 60 | | 2. Extra Strength Vita Joint | | 3. Extra Strength Vita Yin Y | | 4. Extra Strength Vita Yin Y | | 5. Fortified I See 40's | | 6. G.E. Yunzhi Essence 60's | | 7. Glucobest 60's | | 8. Herba Precious 30's | | 9. Herba Precious 30's Twin | | 10. Lingzhi 72's (NB) Twin Pa | | [ 72 others ] |
|
| 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 2790 | ( | 81.8% | ) |
|
 |
19
(0.6%) |
| 8 |
ITEMNAME_CHI
[character] |
| 1. Extra Strength Uricsil 60 | | 2. Lingzhi 72's (New Box) Tw | | 3. Lingzhi K-Cap 72's (NB) T | | 4. Vita Hair 90's Twin Pack | | 5. 活關素特強特效60粒 | | 6. 維特健靈 加強配方 知音蟲草 60粒 (Alu) | | 7. 維特健靈 加強配方 知音蟲草孖裝+加強配方 知音蟲 | | 8. 維特健靈 寧心 60粒 | | 9. 維特健靈 小兒靈芝蜜 250毫升 | | 10. 維特健靈 強效目清素 40粒 | | [ 72 others ] |
|
| 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 62 | ( | 1.8% | ) | | 2790 | ( | 81.8% | ) |
|
 |
19
(0.6%) |
| 9 |
PRODUCTTYPE
[character] |
1. 1 |
|
 |
19
(0.6%) |
| 10 |
ITEMGROUPID
[character] |
| 1. DC | | 2. LZ | | 3. VH | | 4. YY | | 5. DCJ | | 6. HP | | 7. IS | | 8. JT | | 9. YZ | | 10. GB | | [ 20 others ] |
|
| 1023 | ( | 30.0% | ) | | 341 | ( | 10.0% | ) | | 279 | ( | 8.2% | ) | | 186 | ( | 5.5% | ) | | 155 | ( | 4.5% | ) | | 124 | ( | 3.6% | ) | | 124 | ( | 3.6% | ) | | 124 | ( | 3.6% | ) | | 124 | ( | 3.6% | ) | | 62 | ( | 1.8% | ) | | 868 | ( | 25.5% | ) |
|
 |
19
(0.6%) |
| 11 |
Company
[character] |
1. VGHP |
|
 |
19
(0.6%) |
| 12 |
Brand
[factor] |
| 1. VG | | 2. VH | | 3. DC | | 4. NV | | 5. WATON |
|
| 1612 | ( | 47.3% | ) | | 341 | ( | 10.0% | ) | | 1271 | ( | 37.3% | ) | | 124 | ( | 3.6% | ) | | 62 | ( | 1.8% | ) |
|
 |
19
(0.6%) |
| 13 |
SubBrand
[character] |
| 1. Functions | | 2. JointsAndBones | | 3. LZ | | 4. Vitamins | | 5. VH | | 6. YY | | 7. HP | | 8. IS | | 9. YZ | | 10. VC | | [ 16 others ] |
|
| 496 | ( | 15.1% | ) | | 434 | ( | 13.2% | ) | | 403 | ( | 12.3% | ) | | 341 | ( | 10.4% | ) | | 217 | ( | 6.6% | ) | | 186 | ( | 5.7% | ) | | 124 | ( | 3.8% | ) | | 124 | ( | 3.8% | ) | | 124 | ( | 3.8% | ) | | 93 | ( | 2.8% | ) | | 744 | ( | 22.6% | ) |
|
 |
143
(4.2%) |
| 14 |
ProductCategoryName
[character] |
| 1. Capsule | | 2. Chewable | | 3. Foot Patch | | 4. Honey | | 5. Sachet | | 6. Shampoo | | 7. Softgel | | 8. Spray | | 9. Tablet | | 10. Tonic |
|
| 1674 | ( | 55.7% | ) | | 31 | ( | 1.0% | ) | | 62 | ( | 2.1% | ) | | 62 | ( | 2.1% | ) | | 155 | ( | 5.2% | ) | | 31 | ( | 1.0% | ) | | 341 | ( | 11.3% | ) | | 31 | ( | 1.0% | ) | | 589 | ( | 19.6% | ) | | 31 | ( | 1.0% | ) |
|
 |
422
(12.3%) |
| 15 |
ProductSubCategoryName
[character] |
1. Finished Goods |
|
 |
453
(13.2%) |
| 16 |
ProductSubCategoryID
[character] |
| 1. VG_DC_JNB_SOF_FG | | 2. VG_DC_VTM_TAB_FG | | 3. VG_VG_LZ_CAP_FG | | 4. VG_DC_FTN_TAB_FG | | 5. VG_VG_YY_CAP_FG | | 6. VG_DC_FTN_CAP_FG | | 7. VG_VH_VH_CAP_FG | | 8. VG_DC_JNB_TAB_FG | | 9. VG_VG_HP_CAP_FG | | 10. VG_VG_IS_CAP_FG | | [ 31 others ] |
|
| 248 | ( | 7.3% | ) | | 248 | ( | 7.3% | ) | | 217 | ( | 6.4% | ) | | 186 | ( | 5.5% | ) | | 186 | ( | 5.5% | ) | | 155 | ( | 4.5% | ) | | 155 | ( | 4.5% | ) | | 124 | ( | 3.6% | ) | | 124 | ( | 3.6% | ) | | 124 | ( | 3.6% | ) | | 1643 | ( | 48.2% | ) |
|
 |
19
(0.6%) |
| 17 |
YEAR
[integer] |
| Mean (sd) : 2021.8 (0.8) | | min ≤ med ≤ max: | | 2021 ≤ 2022 ≤ 2023 | | IQR (CV) : 1 (0) |
|
| 2021 | : | 1320 | ( | 38.5% | ) | | 2022 | : | 1332 | ( | 38.8% | ) | | 2023 | : | 777 | ( | 22.7% | ) |
|
 |
0
(0.0%) |
| 18 |
MONTH
[integer] |
| Mean (sd) : 5.9 (3.3) | | min ≤ med ≤ max: | | 1 ≤ 6 ≤ 12 | | IQR (CV) : 6 (0.6) |
|
12 distinct values |
 |
0
(0.0%) |
| 19 |
MONTH_ABBR
[character] |
| 1. Apr | | 2. Feb | | 3. Jan | | 4. Jul | | 5. Jun | | 6. Mar | | 7. May | | 8. Aug | | 9. Dec | | 10. Nov | | [ 2 others ] |
|
| 332 | ( | 9.7% | ) | | 332 | ( | 9.7% | ) | | 332 | ( | 9.7% | ) | | 332 | ( | 9.7% | ) | | 332 | ( | 9.7% | ) | | 332 | ( | 9.7% | ) | | 332 | ( | 9.7% | ) | | 221 | ( | 6.4% | ) | | 221 | ( | 6.4% | ) | | 221 | ( | 6.4% | ) | | 442 | ( | 12.9% | ) |
|
 |
0
(0.0%) |